package com.itwill.ecom.member;

import java.sql.Date;

import org.codehaus.jackson.annotate.JsonProperty;
import org.codehaus.jackson.map.annotate.JsonRootName;

/*
	CREATE TABLE MEMBER
	(
    	MEMBER_NO NUMBER(10) NOT NULL PRIMARY KEY,
    	MEMBER_ID VARCHAR2(20) NOT NULL,
    	MEMBER_PASSWORD VARCHAR2(20) NOT NULL,
    	MEMBER_NAME VARCHAR2(20) NOT NULL,
    	MEMBER_BIRTH DATE NOT NULL,
    	MEMBER_ZIP VARCHAR2(20) NOT NULL,
    	MEMBER_ADDR1 VARCHAR2(50) NOT NULL,
    	MEMBER_ADDR2 VARCHAR2(50) NOT NULL,
    	MEMBER_PHONE VARCHAR2(20) NOT NULL,
    	MEMBER_EMAIL VARCHAR2(20) NOT NULL,
    	MEMBER_GRADE NUMBER(10) NOT NULL,
    	MEMBER_NICKNAME VARCHAR2(20) NOT NULL,
    	MEMBER_STATUS VARCHAR2(20),
    	CONSTRAINT MEMBER_FK_GRADE FOREIGN KEY (MEMBER_GRADE)
       						REFERENCES GRADE(GRADE_NO) ON DELETE SET NULL
	);
*/
//@JsonRootName("MemberBeans")
public class MemberBeans {
	//@JsonProperty("member_no")
	int member_no;
	//@JsonProperty("member_id")
	String member_id;
	//@JsonProperty("member_password")
	String member_password;
	//@JsonProperty("member_name")
	String member_name;
	//@JsonProperty("member_birth")
	Date member_birth;
	//@JsonProperty("member_zip")
	String member_zip;
	//@JsonProperty("member_addr1")
	String member_addr1;
	//@JsonProperty("member_addr2")
	String member_addr2;
	//@JsonProperty("member_phone")
	String member_phone;
	//@JsonProperty("member_email")
	String member_email;
	//@JsonProperty("member_grade")
	int member_grade;
	//@JsonProperty("member_nickname")
	String member_nickname;
	//@JsonProperty("member_status")
	String member_status;

	public MemberBeans() {
		// TODO Auto-generated constructor stub
	}

	public MemberBeans(int member_no, String member_id, String member_password,
			String member_name, Date member_birth, String member_zip,
			String member_addr1, String member_addr2, String member_phone,
			String member_email, int member_grade, String member_nickname,
			String member_status) {
		super();
		this.member_no = member_no;
		this.member_id = member_id;
		this.member_password = member_password;
		this.member_name = member_name;
		this.member_birth = member_birth;
		this.member_zip = member_zip;
		this.member_addr1 = member_addr1;
		this.member_addr2 = member_addr2;
		this.member_phone = member_phone;
		this.member_email = member_email;
		this.member_grade = member_grade;
		this.member_nickname = member_nickname;
		this.member_status = member_status;
	}

	public int getMember_no() {
		return member_no;
	}

	public void setMember_no(int member_no) {
		this.member_no = member_no;
	}

	public String getMember_id() {
		return member_id;
	}

	public void setMember_id(String member_id) {
		this.member_id = member_id;
	}

	public String getMember_password() {
		return member_password;
	}

	public void setMember_password(String member_password) {
		this.member_password = member_password;
	}

	public String getMember_name() {
		return member_name;
	}

	public void setMember_name(String member_name) {
		this.member_name = member_name;
	}

	public Date getMember_birth() {
		return member_birth;
	}

	public void setMember_birth(Date member_birth) {
		this.member_birth = member_birth;
	}

	public String getMember_zip() {
		return member_zip;
	}

	public void setMember_zip(String member_zip) {
		this.member_zip = member_zip;
	}

	public String getMember_addr1() {
		return member_addr1;
	}

	public void setMember_addr1(String member_addr1) {
		this.member_addr1 = member_addr1;
	}

	public String getMember_addr2() {
		return member_addr2;
	}

	public void setMember_addr2(String member_addr2) {
		this.member_addr2 = member_addr2;
	}

	public String getMember_phone() {
		return member_phone;
	}

	public void setMember_phone(String member_phone) {
		this.member_phone = member_phone;
	}

	public String getMember_email() {
		return member_email;
	}

	public void setMember_email(String member_email) {
		this.member_email = member_email;
	}

	public int getMember_grade() {
		return member_grade;
	}

	public void setMember_grade(int member_grade) {
		this.member_grade = member_grade;
	}

	public String getMember_nickname() {
		return member_nickname;
	}

	public void setMember_nickname(String member_nickname) {
		this.member_nickname = member_nickname;
	}

	public String getMember_status() {
		return member_status;
	}

	public void setMember_status(String member_status) {
		this.member_status = member_status;
	}

	@Override
	public String toString() {
		return "MemberBeans [member_no=" + member_no + ", member_id="
				+ member_id + ", member_password=" + member_password
				+ ", member_name=" + member_name + ", member_birth="
				+ member_birth + ", member_zip=" + member_zip
				+ ", member_addr1=" + member_addr1 + ", member_addr2="
				+ member_addr2 + ", member_phone=" + member_phone
				+ ", member_email=" + member_email + ", member_grade="
				+ member_grade + ", member_nickname=" + member_nickname
				+ ", member_status=" + member_status + "]";
	}
}

